﻿CREATE TABLE [dbo].[ez_LeaveInfo] (
    [LeaveId]       UNIQUEIDENTIFIER NOT NULL,
    [LeaveTypeId]   UNIQUEIDENTIFIER NOT NULL,
    [LeaveTypeName] NVARCHAR (50)    NOT NULL,
    [UserId]        UNIQUEIDENTIFIER NOT NULL,
    [UserName]      NVARCHAR (50)    NOT NULL,
    [StartTime]     DATETIME         NOT NULL,
    [EndTime]       DATETIME         NOT NULL,
    [Description]   NVARCHAR (200)   NOT NULL,
    [IsAudited]     BIT              NOT NULL,
    [AuditUserId]   UNIQUEIDENTIFIER NULL,
    [AuditUserName] NVARCHAR (50)    NULL,
    [AuditNote]     NVARCHAR (200)   NULL,
    [AuditTime]     DATETIME         NULL
);

